package com.ocean.dao.edu;

import com.ocean.entity.edu.Course;
import com.ocean.entity.edu.Student;
import com.ocean.entity.library.Book;
import com.ocean.entity.user.User;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * @author greenbird
 * @create 2023-03-04 15:20
 */
public interface StudentDao {
    /**
     * 新增*/
    int insert(Student student);
    /**
     * 查询*/
    List<Student> selectAll();

    Student queryById(Integer id);

    /**
     * 删除*/
    int delete(int id);
    /**
     * 修改*/
    int update(Student student);


    List<Student> selectWhere(@Param("sname")String sname, @Param("sex") String sex,@Param("classid") String classid);


    /**
     * 批量新增*/
    int insertBatch(List<Student> list);

    Student selectIdByName(String name);
}
